vlkooup to return multiple values

[midra22]

I'm trying to work out what formula which will be in column C to return values from column Q. please help

[FDibbins]

Hi and welcome to the forum

In a few cases, you have multiple (different) values for a category (A=1 and A=2) Whioch 1 would you want returned?

[midra22]

Hi,
SORRY I meant column A is location a,a,b,b,c,c,d,d column E are locations but not all of them apper twice a,a,b,b,c,,d. I f location C appears only once i need the second C in A column to say "empty"

[midra22]

Hi,
SORRY I meant column A is location a,a,b,b,c,c,d,d column E are locations but not all of them apper twice a,a,b,b,c,,d. I f location C appears only once i need the second C in A column to say "empty"

maybe attachment explains it better?

[FDibbins]

OK I suggest you put your expected answer on that table and show how you got the answers, and then upload again please

[midra22]

in columnB i have formula =IFERROR(VLOOKUP(A1,E1:F9,2,FALSE),"E") than Ctrl+Shift and Enter

[midra22]

this is what i need to get

A B E F

a 1 a 1
a 2 a 2
b 1 b 1
b E c 1
c 1 c 2
c 2 d 1
d 1 d 2
d 2 e 1
e 1 f 1
e E
f 1

[FDibbins]

did you attach your updated workbook?

[midra22]

my first column "A" are locations in column "B" i need a value from "F" which is product name. Column A are all locations in the warehouse but column E only locations that have product in them.

[midra22]

excel.xlsx is this any good?

[FDibbins]

not at all, sorry

It shows an answer but in no-way explains how you arrived at it. As I said before, you have, for instance, 2 values for A, why is "1" the answer for the 1st A and "2" the answer for the 2nd A...why is '1" notthe answer for both? Also, now you suddenly have "E" in there too, where did that come from??

Keep in mind that what may be as clear as day for you, is not so obvious for others that have no knowledge about what you are doing

[midra22]

SORRY for not being clear please look at this attachment which is my work document im trying to get info to column C from Q

[FDibbins]

1st, you dont need to use an array formula for this {}
2nd you need to absolute the range so it doesnt change as you copy down...
=IFERROR(VLOOKUP(B3,$P$3:$S$2148,2,FALSE),"EMPTY LOCATION")

OR if you can have identical headings in each table, you could use this - you then will not need to adjust for subsequent columns as you copy across...

=IFERROR(INDEX($P$2:$S$14,MATCH($B3,$P$2:$P$14,0),MATCH(C$2,$P$2:$S$2,0)),"EMPTY LOCATION")

[midra22]

just tried both, and aren't working, in SKU column it returnes the same products where should br different

[FDibbins]

see the attached

[midra22]

PLEASE see attachment I highlighted where is an issue, sorry I'm a pain

[FDibbins]

OK i see the duplicate locations. AGAIN I ask...

As I said before, you have, for instance, 2 values for A, why is "1" the answer for the 1st A and "2" the answer for the 2nd A...why is '1" not the answer for both?

[midra22]

because on the system location is set up to hold two product thats why I've got location repeated twice so I can see which products are there and if is only one product then 2nd location will say empty