Hello
I want to lookup 2 values from a row with multiple columns - I attached the spreadsheet. Pls help
Hello
I want to lookup 2 values from a row with multiple columns - I attached the spreadsheet. Pls help
Try this:
=INDEX('Incident Summary'!$F$47:$BA$47,,MATCH(Coastal!$D$1,'Incident Summary'!$F$27:$BA$27,0)+MATCH(B4,'Incident Summary'!$F$28:$I$28,0)-1)
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
In E4, enter:
Formula:Please Login or Register to view this content.
Copy to E4:E7.
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
I thank you sooooooooooooo much - would never have worked this out myself. perfect solution
Both are working
You're welcome.
If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.
It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.
Last question pls - this worksheet is reading from a different workbook (also formulas) and only updates if the workbook is open else it gives #VALUE!
I have tried everything excel suggest but cannot get it right.
Mine should work OK. Do you have the full path in the formulae?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks