Cameron has attended:
Excel Advanced course
VLOOKUP Function
Hello,
I need a little bit of help with a VLOOKUP.
Is it possible to run a VLOOKUP function on a list of data and if the 'lookup value' is not found in the source data, instead of returning '#N/A' the value remains as it was originally?
Does this make sense?
Many thanks,
Cameron
RE: VLOOKUP Function
Hi Cameron,
It sounds like you need a formula to swap out the #N/A when you get it.
You might need the IFNA function
=IFNA(Value,Alternative if there is an #N/A error)
That would look like this if A1 is your lookup value
=IFNA(VLOOKUP(A1,Table Array,Col Num,FALSE),A1)
Does that help?
Kind regards
Richard Bailey
Microsoft Certified Trainer
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector