I have a spreadsheet with several columns. Is there a way to find corresponding values for column A? for example if I type a value from column A "bexar" - A 3 can I get the corresponding contents of B3, or C3 to display with a formula?
2006-08-24 06:57:06 · 3 answers · asked by Excel 1 in Computers & Internet ➔ Software
What you are looking for is either "VLOOKUP" fuction.
It is also possible to use the "Data Filter"
Look into the help section. I am sure you will find a solution.
2006-08-25 14:39:20 · answer #1 · answered by Dilip Rao 3 · 1⤊ 0⤋
Let me see if I get you right.
You have columns A, B, and C with values, you want to type one of col A values (say in H2) and the corresponding values in B and C will show in I2 and J2.
If so, paste this function in i2
=vlookup( h2,A:C,2, false)
and paste this in J2
=vlookup( h2,A:C,3, false)
BUT remove the spaces from it first.
Rad my profile, I am XLMan
2006-08-26 05:11:42 · answer #2 · answered by Anonymous · 0⤊ 0⤋
I think you want a VLOOKUP, not sure though, you are very vague
2006-08-24 14:07:33 · answer #3 · answered by Icon 7 · 0⤊ 0⤋