Need Looking up Farmula or Function

**Sher Muhammad** · 03-30-2013, 07:55 AM

Asslam o Alaikom,

I wants b16 look up in column A of sheet invoice summary and

g16, i16, k16, m16 look up from column E of sheet invoice summary

Please help me

Thanks

**Harribone** · 03-30-2013, 08:10 AM

On the 'INVOICE SUMMARY SHEET' Insert 2 columns in between A and B (between SITE ID and MODEL). Call them '1/2/3/4' and 'JOIN'.

If the SITE ID refers to the '1st inv' type 1 into '1/2/3/4', if it refers to the '2nd inv' type 2 etc.
In the JOIN column type into C6 =A6&B6 and drag down. This puts the SITE ID and 1/2/3/4 together as one string (used to search in VLOOKUP below).

Now on the 'SITEWISE CLOSING' tab type the below formulas:

G16
=IFERROR(VLOOKUP($B16&1,'INVOICE SUMMARY'!$C:$G,5,0),"")
I16
=IFERROR(VLOOKUP($B16&2,'INVOICE SUMMARY'!$C:$G,5,0),"")
K16
=IFERROR(VLOOKUP($B16&3,'INVOICE SUMMARY'!$C:$G,5,0),"")
M16
=IFERROR(VLOOKUP($B16&4,'INVOICE SUMMARY'!$C:$G,5,0),"")

These can be dragged up/down to populate the rest.

**Sher Muhammad** · 03-30-2013, 09:35 AM

Thank you Very Much

**Harribone** · 03-30-2013, 09:48 AM

Not a problem! That's what we are here for.

Please take the time to mark this thread as SOLVED by using the Thread Tools at the top of the page

**Sher Muhammad** · 03-30-2013, 10:18 AM

I am sorry that I have not found any tool box because I am a new user. can you tell me where is tool box.

**Sher Muhammad** · 03-30-2013, 10:20 AM

Thak you sir, I found that

Need Looking up Farmula or Function

LinkBack

Thread Tools

Rate This Thread

Display

Need Looking up Farmula or Function

Re: Need Looking up Farmula or Function

Re: Need Looking up Farmula or Function

Re: Need Looking up Farmula or Function

Re: Need Looking up Farmula or Function

Re: Need Looking up Farmula or Function

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions