Vlookup Help

[djmnon]

Sheet 1 - This has a code column
Sheet 2 - this also has a code column

Expected result

Sheet2 also has a column where in Codes Values are Yes and No values are mentioned

So when I do Vlookup based on Matching Code Names I want to match it with the Code Values and return the results as Yes and No

To make it more clear please see below screenshots

So for eg :- Sheet 1- A column has a number that says 348 and in the E column it has corresponding value as No

so if the 348 number matches in the other Sheet (Sheet2) then it shouldn't show the matching number but instead it should show the value from Sheet1 in column E which is No / Yes.

Can this be done?

 

[etaf]

then it shouldn't show the matching number but instead it should show the value from Sheet1 in column E which is No / Yes.

can this be a new column , with the result from vlookup
if not then VBA will be needed to change an existing cell value , as far as i know , which is not my area

otherwise

In a new column on Sheet2 and copy down , change the range rows to your data
=index(sheet1!$E$2:$E$1000, Match(sheet2!A2,sheet1!$A$2:$A$1000,0)

as i say - if it is

but instead it should show the value from Sheet1

Then as far as i know that may need VBA , or another member may have more knowledge and provide a solution , but i dont know

 

[djmnon]

can this be a new column , with the result from vlookup

Should be a problem even we put that in new column as well in Sheet2 as long as it matches with the YES and No values from Sheet1 E column. If thats the case whats the code for it?

Also this is my Vlookup function as now :- How do I modify it to achieve the above

=VLOOKUP(A2,'[Copy of CDM_RDO_Onhold_List_2022-04-13.xlsx]Sheet1'!$A:$F,1,0)

 

[etaf]

This will bring back the first column A in [Copy of CDM_RDO_Onhold_List_2022-04-13.xlsx]Sheet1'!$A:$F
is this a different workbook ?

to get the YES/NO from column E
=VLOOKUP(A2,'[Copy of CDM_RDO_Onhold_List_2022-04-13.xlsx]Sheet1'!$A:$F,5,0)

 

[djmnon]

Yes its a different workbook.

 

[etaf]

you cannot use vlookup , if the workbook is closed, that will need VBA , which I do not do.

if you open the Copy of CDM_RDO_Onhold_List_2022-04-13.xlsx
and then open the book with the vlookup in
did you try
=VLOOKUP(A2,'[Copy of CDM_RDO_Onhold_List_2022-04-13.xlsx]Sheet1'!$A:$F,5,0)
NOTE the number has changed to 5 , so its looking up the value in column A as that is the start of the range , then counting 5 columns including A to get the value corresponding to the lookup
A,B,C,D,E
so column E is the 5th column

 

[Alex Blakenburg]

you cannot use vlookup , if the workbook is closed,

Yes you can. From memory as long as you don't also use Indirect in the formula.

 

[etaf]

Yes you can.

Oh, yes, you are correct , its the indirect i got mixed up with , thankyou for correcting

So , back to the OP,, *djmnon
why did it not work, whats the error