Lookup and fill values

[rollingzep]

Hi,

I have two sheets on the same WB.
Sheet1 contains CUS_ID and MARKET_DESC. Sheet2 contains few fields like product, matdate ..... and ST

I need product from Sheet2 to look up the values of CUS_ID of Sheet1 and fill the ST field in Sheet2 with the values of MARKET_DESC from Sheet1.

Test.xlsx
	G
11	I
Sheet2

Test.xlsx
	D
9
Sheet1

Thanks

 

[etaf]

I need product from Sheet2 to look up the values of CUS_ID of Sheet1 and fill the ST field in Sheet2 with the values of MARKET_DESC from Sheet1.

=index(Sheet1!MArket_Desc-Cell-range to return , match( Sheet2!Product cell , Sheet1!Cus_ID-cell-Range of cell , 0))

I think thats whats needed the XL2BB, has little in , and i cant make out exactly what you need

 

[rollingzep]

=index(Sheet1!MArket_Desc-Cell-range to return , match( Sheet2!Product cell , Sheet1!Cus_ID-cell-Range of cell , 0))

I think thats whats needed the XL2BB, has little in , and i cant make out exactly what you need

Hi,

<p>
I have pasted a bigger sample of data. I wanted to do this with Excel VBA code.

I have two sheets on the same WB.
Sheet1 contains CUS_ID and MARKET_DESC. Sheet2 contains few fields like product, matdate ..... and ST

I need product from Sheet2 to look up the values of CUS_ID of Sheet1 and fill the ST field in Sheet2 with the values of MARKET_DESC from Sheet1.
</p>

 

[etaf]

I wanted to do this with Excel VBA code.

Sorry , I dont provide VBA solutions here

 

[rollingzep]

Sorry , I dont provide VBA solutions here

Thanks, but I though all Excel issues were discussed in this forum.

 

[etaf]

but I though all Excel issues were discussed in this forum.

yes they are , but i personally do not provide any VBA solutuions , so cannot help you , other members will i'm sure

maybe useful to close this thread and start a new one - and say in the title you only want VBA solution