Perhaps use VLOOKUP function in column AM of workbookA. Check help for more
details. Be sure to Adjust the range for workbookB to whatever your actual
range is.
=VLOOKUP(A1,[WorkbookB.xls]Sheet1!$A$1:$G$15,7,FALSE)
Then copy the formula down column AM. To hardcode the values, select column
AM, click copy, then Edit/Paste Special and select values option.
To avoid #N/A for items that have no match, use
=IF(ISNUMBER(MATCH(A1,[WorkbookB.xls]Sheet1!$A$1:$A$15,0)),VLOOKUP(A1,[WorkbookB.xls]Sheet1!$A$1:$G$15,7,FALSE), "")
"Les Stout" wrote:
Hi all, i have struck a blank and must have this finished by morning !!
need to go down column A of workbookA and look up the value of the cells
in A in workbookB, if found place the order number from column G in the
column AM of the workbookA. I have tried various options from this site
but just cannot get it to work. Any help is gratefully accepted.
Les Stout
*** Sent via Developersdex http://www.developersdex.com ***