Amend columns in a formula that lookup values from temp sheet

Hi...i have this code below....what is does is take columns BA:BB into a Sheet1 into a temp sheet and sort it so that Sheet1 column AX can be populated with a formula that looks for column A in Column BA and returns BB...but the lookup happens in the temp sheet..so column BA and BB are columns A and B in the temp sheet.

I need to change it so that the AV is the column that has the lookup formula and AB is the column that has the value being looked up...i've tried to amend it but habe had no luck.

Please Login or Register  to view this content.

Hi sukyb1


Suggest you to change the thread title to reflect the query being asked. see the forum rules:-

http://www.excelforum.com/forum-rule...rum-rules.html

Also you did not follow the Code Tag rule. Any VBA code should be surrounded with code tags.

Regards,
DILIPandey

<click on below 'star' if this helps>

Thanks Dilip.

Sukyb1,

Welcome to the forum.

I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. If you need more information on how to use them, check my signature.

You only need to amend the title now.