Hello everyone,

I'm new to this forum and fairly new to Excel. I started out using Google Sheets as my frist spreadsheet software.

Here's my question (maybe a stupid one):

I need to look up a certain value and it needs to return multiple values from another sheet, so I used an array formula with VLOOKUP. But now I would like to somehow combine or wrap it with IFNA(). Does anyone know how?

Thanks guys.

This is my code:

{=VLOOKUP(A1, '\\SBS2011\RedirectedFolders\bruce\My Documents\Dairy_Frozen\PO_SHEETS\[MEAT_LOOKUP.xlsx]Sheet1'!$A$1:$D$500, {2,3,4}, FALSE)}