too many arguments for this function (=vlookup)

[lmsafety]

Hi,

I'm using this formula =LOOKUP(H1448,'[Copy of SS2021 Fristads Price List EURO by Style Colour.xlsx]EURO Pricing Jan - Jun 2021'!$A$6:$H$6,8,FALSE)

It reads okay to me but is returning the error too many arguments for this function. Any advice is greatly appriciated.

 

[mart37]

This look like VLOOKUP.

 

[lmsafety]

oh what a silly error - I think i have been trying to sort if out for so long that I eventually forgot to put the V in front! Thank you so much!

This worked BUT it only worked for the first two cells and the remaining 100+ say N/A ?

 

[mart37]

$A$6:$H$6 is only one row. You need to give up the address of the whole table.

 

[lmsafety]

thank you so much - so helpful!