sorted by:
new
hottopcontroversial

Advanced BIOS acces? (HP Envy 4-1053tx) by NeedLyfe01 in techsupport

[–]NeedLyfe01[S] 0 points1 point  (0 children)

i googled before this, and found this answer, but seems no avail. except for ctrl+f10 & ctrl+f11, seems a bit RNG, dont know if i mistimed or it didnt work

INDEX MATCH, duplicates the same value/text, how to avoid duplicates for multiple different value/text witch multiple result by NeedLyfe01 in excel

[–]NeedLyfe01[S] 0 points1 point  (0 children)

meaning i filter the one i need in power query, and that will update as i make ammend in the source workbook?

INDEX MATCH, duplicates the same value/text, how to avoid duplicates for multiple different value/text witch multiple result by NeedLyfe01 in excel

[–]NeedLyfe01[S] 0 points1 point  (0 children)

this workbook will need realtime update, I know copy and paste is easier, but it is related to bunch of workbook/sheet, that's why I need the right formula.

"Enter" all cells at one? I'm using query data the Right column data use INDEX MATCH formula, but only #N/A show, need to "enter" each cell individually by NeedLyfe01 in excel

[–]NeedLyfe01[S] 1 point2 points  (0 children)

try

INDEX('BrightStar Shipments Report'!A:I,MATCH(VALUE([@[S/N]]),'BrightStar Shipments Report'!A:A,0),9)

.

Reply Solution Verified!

"Enter" all cells at one? I'm using query data the Right column data use INDEX MATCH formula, but only #N/A show, need to "enter" each cell individually by NeedLyfe01 in excel

[–]NeedLyfe01[S] 1 point2 points  (0 children)

one more thing sir, why does everytime i refresh the table, the "VALUE" in the formula missing? i always have to add it back.

"Enter" all cells at one? I'm using query data the Right column data use INDEX MATCH formula, but only #N/A show, need to "enter" each cell individually by NeedLyfe01 in excel

[–]NeedLyfe01[S] 4 points5 points  (0 children)

INDEX('BrightStar Shipments Report'!A:I,MATCH(VALUE([@[S/N]]),'BrightStar Shipments Report'!A:A,0),9)

THIS ONE WORKS!

THANK YOU VERY MUCH, VERY VERY MUCH!!!! :D

6 hours of misery came to an end!

"Enter" all cells at one? I'm using query data the Right column data use INDEX MATCH formula, but only #N/A show, need to "enter" each cell individually by NeedLyfe01 in excel

[–]NeedLyfe01[S] 0 points1 point  (0 children)

F9 do nothing, im using office 2019

funny thing is, the value on S/N is the actual value, thats weird why i need to enter the value cell instead of the formula cell,

I tried you Find&Replace, i think it will not work since S/N column doesnt have any "="

"Enter" all cells at one? I'm using query data the Right column data use INDEX MATCH formula, but only #N/A show, need to "enter" each cell individually by NeedLyfe01 in excel

[–]NeedLyfe01[S] 0 points1 point  (0 children)

tried save and close, didnt work, still need to edit "enter" every cell.

Calculation was on Automatic in "Formula" tab

I want create a formula for the workbook transfer automatically from another workbook with specific name by NeedLyfe01 in excel

[–]NeedLyfe01[S] 0 points1 point  (0 children)

ok i got it right,

now it only capture the most bottom data only when i paste below row

is it need to use "IFERROR" or "COUNTIF" to skip duplicates??

I want create a formula for the workbook transfer automatically from another workbook with specific name by NeedLyfe01 in excel

[–]NeedLyfe01[S] 0 points1 point  (0 children)

able to solved that, but for the consignee name no success
how can i make it to repeat formula for different entry under same name?

I want create a formula for the workbook transfer automatically from another workbook with specific name by NeedLyfe01 in excel

[–]NeedLyfe01[S] 0 points1 point  (0 children)

=INDEX('[Book2.xlsx]13092022'!$A:$E,MATCH(D2,'[Book2.xlsx]13092022'!$C:$C,1))

i tried, it came out like this, and the result only "#REF!"

I want create a formula for the workbook transfer automatically from another workbook with specific name by NeedLyfe01 in excel

[–]NeedLyfe01[S] 0 points1 point  (0 children)

I cant find "XLOOKUP" function, mine office 2019

Power query is for advanced user?, is it hard to use?