I am not sure that I will be able to phrase this question they way I'd like, but here it goes. I would like to use an equation (not even sure if thats the best way to do this) to grab a value in a column next to a value of my choosing. Might be easier to display what I'm trying to do:
column a , column b , column c , column d
92.14 , #1 , 92.13 , 92.05
92.16 , #2 , 92.14 , 92.06
92.18 , #3 , 92.15 , 92.07
So i would like to use an equation in column b to insert the value from column d that is next to the like values (from columns a and c). So in my above example, I would like to have the value 92.06 in column b next to 92.14 (#1).
Sorry if this is as clear as mud
Last edited by markley; 08-12-2010 at 02:21 PM.
You need to update your title....something like "Selecting value by matching 2 values"
ChemistB
My 2¢
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
I think this is what you are looking for... In B1
=VLOOKUP(A1,$C$1:$D$3,2,FALSE) Change $C$1:$D$3 to cover your entire range. To keep from getting an error when it finds nothing use
=ISERROR(VLOOKUP(A1,$C$1:$D$3,2,FALSE),"")
Is that what you are looking for?
Last edited by ChemistB; 08-12-2010 at 02:50 PM.
ChemistB
My 2¢
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
That worked perfectly!! Thanks so much!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks