Hello and thank you for your question today. My name is Jason. I look forward to helping you today.
This can be done very easily with the VLOOKUP function.
In this example, I will assume that Column A has the numbers you wish to match and Column B is the value that you wish to return.
I have been trying to get it to work and not having any luck
OK - go for it
Here is the formula:=VLOOKUP("Value",A1:B10,2,FALSE)
What that formula will do is look for the value "Value" in the table A1:B10
When it finds the value, it will return the value in the 2nd column, which is the B column in this case.
Does that make sense?
You would replace "Value" with the value you are looking for, replace A1:B10 with your table values.
Also, you could replace "Value" with a cell reference.
this is the formula i have tried - =VLOOKUP(AF2,Vital,15,FALSE) and I have asked it to look at the number in cell af2, check it in the table I have called Vital, then return the figure that is in the 15th column but only if it is an exact match?
does that make sense?
That is the correct formula for such.
well it keep giving me "n/a"!
Thank you for the update.May I please, start a remote screen sharing session with you so that I can better help you resolve this problem? No extra charge.
Thank you.Please, click the following link and allow the remote app to run: http://126.96.36.199:8040/?Session=42c429cb-84cf-4a66-9ea8-e0877c389dea
Please, allow all to run.
Thank you for your time.
Here is the end formula that works for the first row: =IF(OR(ISNA(VLOOKUP(VALUE(AF2),$H$2:$R$26232,11,FALSE)),NOT(ISNUMBER(VALUE(AF2))))," ",VLOOKUP(VALUE(AF2),$H$2:$R$26232,11,FALSE))
I look forward to your next message or your rating below. To rate me, you can click one of the faces below and click Submit/Ok or click the Accept button.If you ever wish to work with me in the future, you can ask your new questions and have them sent to me directly at the following page: http://www.justanswer.com/computer/expert-computertechmaster/Thank you again, - Jason
You can book mark the link above, if you wish.
Thank you again.