Hi
I am trying to retrieve corresponding value from a table;
Table as under
411659 $129.00 $193.00 $187.00 $136.00 $180.00 $108.00
407345 $154.00 $178.00 $118.00 $189.00 $184.00 $130.00
419885 $105.00 $116.00 $115.00 $116.00 $128.00 $136.00
414030 $102.00 $199.00 $156.00 $139.00 $170.00 $103.00
416372 $191.00 $123.00 $166.00 $141.00 $114.00 $137.00
410398 $102.00 $178.00 $147.00 $109.00 $191.00 $100.00
414336 $162.00 $110.00 $170.00 $179.00 $161.00 $164.00
417560 $170.00 $160.00 $179.00 $180.00 $162.00 $115.00
404455 $198.00 $105.00 $157.00 $115.00 $148.00 $121.00
If i type in cell A1 , 109 then in A2 i need a formula that looks up to give me the corresponding account number from the table which is 410398. This formula should be able to look-up any amounts from the table. So should i type in 121 in cell A1, then i should see account number 404455 in cell A2...
Any ideas?
I am trying to retrieve corresponding value from a table;
Table as under
411659 $129.00 $193.00 $187.00 $136.00 $180.00 $108.00
407345 $154.00 $178.00 $118.00 $189.00 $184.00 $130.00
419885 $105.00 $116.00 $115.00 $116.00 $128.00 $136.00
414030 $102.00 $199.00 $156.00 $139.00 $170.00 $103.00
416372 $191.00 $123.00 $166.00 $141.00 $114.00 $137.00
410398 $102.00 $178.00 $147.00 $109.00 $191.00 $100.00
414336 $162.00 $110.00 $170.00 $179.00 $161.00 $164.00
417560 $170.00 $160.00 $179.00 $180.00 $162.00 $115.00
404455 $198.00 $105.00 $157.00 $115.00 $148.00 $121.00
If i type in cell A1 , 109 then in A2 i need a formula that looks up to give me the corresponding account number from the table which is 410398. This formula should be able to look-up any amounts from the table. So should i type in 121 in cell A1, then i should see account number 404455 in cell A2...
Any ideas?