Dear Sir /Madam,
In the given file, where I have to match between column A and F. in F column few values are missing. According to A col, the cols F,G,H,I,J,K,L has to replaced in matching with A col. For easy understanding , I have did manually in the 2 sheet (required output sheet) for your kind reference.
please do help me... like this I have to do for 10 more files...
I need very urgently...please oblige and do the needful...
please find the attachment...
Thanks & Regards,
Dharani.
Hello, and welcome to the forum.
I think that this can be done with a VLOOKUP function. If you have Excel 2007 or later you can use the IFERROR function (1) below, which is a much shorter way to deal with look up errors than the pre-2007 IF(ISERROR(.
Which makes a much longer formula (2) below. On your "required input" sheet copy either 1 or 2 below across and down columns F to L starting at F2. Im assuming that the number of data rows on both sheets will be the same, on the final version.
Before copying extend array F2:L433 to cover your full data set.
Formula (1) - Excel 2007 and later
=IFERROR(VLOOKUP($A2,'input sheet'!$F$2:$L$433,COLUMN(A$1),FALSE), "")
Formula (2) Excel 2003 and earlier:
=IF(ISERROR(VLOOKUP($A2,'input sheet'!$F$2:$L$433,COLUMN(A$1),FALSE)),"",(VLOOKUP($A2,'input sheet'!$F$2:$L$433,COLUMN(A$1),FALSE)))
If you can live with the VLOOKUP error reporting, you can leave out the error coding.
Good luck,
Hercules
Last edited by Hercules1946; 2013-09-30 at 09:29 PM.
Bookmarks