Vlookup for multiple columns

[Alpha Zero]

I've attached a sample of what I'm trying to accomplish.
I am trying to have VLookup pull the values from multiple columns.
In my sample, I am working on getting the data from the "Prices" sheet, to the "Worksheet." I want to pull the last price and cost. As you can see on the sample, they are not all on the same columns. I want it to pull the last cost and last price from the most recent PO and if that field is blank, move to the next most recent PO.
Thanks!

[NBVC]

I don't see a "Prices" sheet nor a "Worksheet" sheet...

Can you clarify where the info is coming from and where you want to see the results? Also, please give an example of an expected result.

[Alpha Zero]

Sorry, I attached the incorrect file.
I've attached the correct one now.
I also added a worksheet labeled "Results" to give an example of what should be in there at the end.
Thanks!

[NBVC]

Firstly, your entries in Order Entry must be formatted the same as your entries in the other sheets... so go to Order Entry and select column A.. then go to Data|Text to Columns and click Finish.. now everything is formatted as General.

Then, I am not sure why you reference Order Entry in your Vlookup formulas on the Worksheet sheet.... you should reference column A on the Worksheet sheet...so change formula in B3 of Worksheet to:

Please Login or Register  to view this content.

Then in formula in E3 is:

Please Login or Register  to view this content.

and in F3:

Please Login or Register  to view this content.

both these formulas need to be individually confirmed with CTRL+SHIFT+ENTER not just ENTER. You will see { } brackets appear around them...

Then copy them down..

See attached.

[Alpha Zero]

That worked perfectly! Thanks a bunch!

Sidenote:
Is there a way to show blanks instead of #N/A on the blank vlookups?

[NBVC]

That worked perfectly! Thanks a bunch!

Sidenote:
Is there a way to show blanks instead of #N/A on the blank vlookups?

You're welcome...


to show blanks instead of #N/A, you need an error trap...

e.g.

Please Login or Register  to view this content.

[Alpha Zero]

The error trap has worked great.
Now I have another question. Is there also a way to setup an error trap for words? I've tried a few combinations of ISERROR and what not and can't seem to figure out the correct way to do it.
Thanks again for all the help.

[franciz]

Try using ISERROR instead

[franciz]

sorry, I meant that you can use ISTEXT to trap for strings