Excel 2007 : problem with a vlookup\if

**Roadhogg71** · 04-23-2012, 08:03 AM

Hello all, I have a solution im trying to solve here. in column 3 i have names.. I want my sheet to search all the names, then in columns D to H, I have a code or Letters.

so if it finds the A, it is pasted to one part of my sheet, finds an NP, pasted elsewhere, and so on. It needs to input the entire row when it finds the corosponding letter. from column A to the End... I attached an example of the sheet, without formatting or anything, but you get the idea... Thanks in advance..

**NBVC** · 04-23-2012, 08:08 AM

I don't understand you sample results?

Why all the 1's and some B's and B2's in the mix?

Please elaborate

**Roadhogg71** · 04-23-2012, 08:16 AM

the 1s, Bs, and Bs, are just calculations for the name in the row that is currently being inputted else where.... but i also need it to search all names and look for an A in column D, paste whole row... finds a name with an NP from column E, paste whole row... and so on, so forth..

Thanks

**tigertiger** · 04-23-2012, 08:24 AM

Originally Posted by Roadhogg71

the 1s, Bs, and Bs, are just calculations for the name in the row that is currently being inputted else where.... but i also need it to search all names and look for an A in column D, paste whole row... finds a name with an NP from column E, paste whole row... and so on, so forth..
Thanks

It is more confusing,
Plz attach sample results as you wish

**NBVC** · 04-23-2012, 08:24 AM

is there a sample of expected results anywhere then?

**Roadhogg71** · 04-23-2012, 08:31 AM

Ok, here is more data i threw into sheet... as you notice..... lower, names with an A are catagorized, then NP... and so on... its not as simple as a sort though, it needs to put the data of the whole row into a seperate part of the sheet..

Thanks