Cell from one tab matches any from a range and populates another cell.

[jtmann]

Formula to search a range of cells on a different tab and populate with the data in the cell beside the match.

Please see attached.

[JohnTopley]

Try

=IFERROR(VLOOKUP(C3,Current!A2:B28,2,0),"")

BUT make sure you bottle type in Current and PIE match

"40ml AG Vial w/HCL" vs "(3) 40ml AG Vial w/HCL"

[BillyRaySpivy]

Good morning,

I removed the numbers in parenthesis on the "Pie" worksheet because they interfere with the match.

Put this in your cell D3 on the Printable worksheet:

Please Login or Register  to view this content.

I hope this helps.