I think you are looking for the VLOOKUP function. If you type in the formula shown below into cell I3 on worksheet L1-6, the formula will return 3.864, the Euro Chop Price for that item.
=VLOOKUP(G3,'Arquadia supplier'!$A$2:$G$2443,7,FALSE)
I think you are looking for the VLOOKUP function. If you type in the formula shown below into cell I3 on worksheet L1-6, the formula will return 3.864, the Euro Chop Price for that item.
=VLOOKUP(G3,'Arquadia supplier'!$A$2:$G$2443,7,FALSE)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks