How to v lookup & use if statement?

**floricita** · 09-03-2010, 05:34 AM

Ok this is the problem I have.

I have posted a sample.

I need to fill in the data for week 8 and nine and the data to be included is from col N-Qso basically the unique identifier is the shop no, col A with raw data col N&P.

In Col O&Q is the raw data which gives a score, this then needs to go in col E-K(what will be L&M for wk 8 and 9) but using the abbreviations A=avberage,G=Good,NR= No report, P=Poor, Blanks I have been told =NR also but can be left blank.

Any help would be great as i'm really stuck

.

**windknife** · 09-03-2010, 06:13 AM

L9

Please Login or Register  to view this content.

M9

Please Login or Register  to view this content.

copied down.

HTH,
WindKnife

**floricita** · 09-03-2010, 06:34 AM

I know its really cheeky, but is it possible to also do the same for this one please? (last one I have to do)

Thank you so much again

**floricita** · 09-03-2010, 06:37 AM

Sorry that was the same one again.

I meant this one

**floricita** · 09-03-2010, 06:46 AM

Actually I managed to do that one.

thanks again for your help, it is greatly appreciated.

**floricita** · 09-03-2010, 08:05 AM

Hi.

I was just curious for my own knowledge what the following actually means in simple terms?

I get the formula up to the point

"="","NR",LEFT(INDEX($O$11:$O$2000,MATCH($A488,$N$11:$N$2000,0)),1)),"NR")

Is it possible to explain this process in basic speak please?

Thank you, and thank you again for helping